using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace SC.CodeBuilder
{
    public class BuilderDALELParam_aaaaaaaaa
    {
        private static string RetrunType;
        public static string ConvertType(string Type)
        {
            switch (Type.Trim())
            {
                case "char": RetrunType = "AnsiString"; break;
                case "varchar": RetrunType = "AnsiString"; break;
                case "text": RetrunType = "AnsiString"; break;
                case "datetime": RetrunType = "DateTime"; break;
                case "smdlldatetime": RetrunType = "DateTime"; break;
                case "nchar": RetrunType = "String"; break;
                case "nvarchar": RetrunType = "String"; break;
                case "ntext": RetrunType = "String"; break;
                case "binary": RetrunType = "Binary"; break;
                case "varbinary": RetrunType = "Binary"; break;
                case "image": RetrunType = "Image"; break;
                case "bit": RetrunType = "Boolean"; break;
                case "tinyint": RetrunType = "Byte"; break;
                case "smallint": RetrunType = "Int64"; break;
                case "int": RetrunType = "Int32"; break;
                case "bigint": RetrunType = "Int64"; break;
                case "numeric": RetrunType = "Decimal"; break;
                case "decimal": RetrunType = "Decimal"; break;
                case "int identity": RetrunType = "Int32"; break;
                case "smallmoney": RetrunType = "Currency"; break;
                case "money": RetrunType = "Currency"; break;
                case "float": RetrunType = "Double"; break;
                case "real": RetrunType = "Decimal"; break;
                default: RetrunType = "1"; break;
            }
            return RetrunType;
        }
    }
}
